package com.intellagric.pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TraceCompanyExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TraceCompanyExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("id like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("id not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCompaneNameIsNull() {
            addCriterion("compane_name is null");
            return (Criteria) this;
        }

        public Criteria andCompaneNameIsNotNull() {
            addCriterion("compane_name is not null");
            return (Criteria) this;
        }

        public Criteria andCompaneNameEqualTo(String value) {
            addCriterion("compane_name =", value, "companeName");
            return (Criteria) this;
        }

        public Criteria andCompaneNameNotEqualTo(String value) {
            addCriterion("compane_name <>", value, "companeName");
            return (Criteria) this;
        }

        public Criteria andCompaneNameGreaterThan(String value) {
            addCriterion("compane_name >", value, "companeName");
            return (Criteria) this;
        }

        public Criteria andCompaneNameGreaterThanOrEqualTo(String value) {
            addCriterion("compane_name >=", value, "companeName");
            return (Criteria) this;
        }

        public Criteria andCompaneNameLessThan(String value) {
            addCriterion("compane_name <", value, "companeName");
            return (Criteria) this;
        }

        public Criteria andCompaneNameLessThanOrEqualTo(String value) {
            addCriterion("compane_name <=", value, "companeName");
            return (Criteria) this;
        }

        public Criteria andCompaneNameLike(String value) {
            addCriterion("compane_name like", value, "companeName");
            return (Criteria) this;
        }

        public Criteria andCompaneNameNotLike(String value) {
            addCriterion("compane_name not like", value, "companeName");
            return (Criteria) this;
        }

        public Criteria andCompaneNameIn(List<String> values) {
            addCriterion("compane_name in", values, "companeName");
            return (Criteria) this;
        }

        public Criteria andCompaneNameNotIn(List<String> values) {
            addCriterion("compane_name not in", values, "companeName");
            return (Criteria) this;
        }

        public Criteria andCompaneNameBetween(String value1, String value2) {
            addCriterion("compane_name between", value1, value2, "companeName");
            return (Criteria) this;
        }

        public Criteria andCompaneNameNotBetween(String value1, String value2) {
            addCriterion("compane_name not between", value1, value2, "companeName");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("email is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("email is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("email =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("email <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("email >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("email >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("email <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("email <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("email like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("email not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("email in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("email not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("email between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("email not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andTelIsNull() {
            addCriterion("tel is null");
            return (Criteria) this;
        }

        public Criteria andTelIsNotNull() {
            addCriterion("tel is not null");
            return (Criteria) this;
        }

        public Criteria andTelEqualTo(String value) {
            addCriterion("tel =", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelNotEqualTo(String value) {
            addCriterion("tel <>", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelGreaterThan(String value) {
            addCriterion("tel >", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelGreaterThanOrEqualTo(String value) {
            addCriterion("tel >=", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelLessThan(String value) {
            addCriterion("tel <", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelLessThanOrEqualTo(String value) {
            addCriterion("tel <=", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelLike(String value) {
            addCriterion("tel like", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelNotLike(String value) {
            addCriterion("tel not like", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelIn(List<String> values) {
            addCriterion("tel in", values, "tel");
            return (Criteria) this;
        }

        public Criteria andTelNotIn(List<String> values) {
            addCriterion("tel not in", values, "tel");
            return (Criteria) this;
        }

        public Criteria andTelBetween(String value1, String value2) {
            addCriterion("tel between", value1, value2, "tel");
            return (Criteria) this;
        }

        public Criteria andTelNotBetween(String value1, String value2) {
            addCriterion("tel not between", value1, value2, "tel");
            return (Criteria) this;
        }

        public Criteria andWebAddressIsNull() {
            addCriterion("web_address is null");
            return (Criteria) this;
        }

        public Criteria andWebAddressIsNotNull() {
            addCriterion("web_address is not null");
            return (Criteria) this;
        }

        public Criteria andWebAddressEqualTo(String value) {
            addCriterion("web_address =", value, "webAddress");
            return (Criteria) this;
        }

        public Criteria andWebAddressNotEqualTo(String value) {
            addCriterion("web_address <>", value, "webAddress");
            return (Criteria) this;
        }

        public Criteria andWebAddressGreaterThan(String value) {
            addCriterion("web_address >", value, "webAddress");
            return (Criteria) this;
        }

        public Criteria andWebAddressGreaterThanOrEqualTo(String value) {
            addCriterion("web_address >=", value, "webAddress");
            return (Criteria) this;
        }

        public Criteria andWebAddressLessThan(String value) {
            addCriterion("web_address <", value, "webAddress");
            return (Criteria) this;
        }

        public Criteria andWebAddressLessThanOrEqualTo(String value) {
            addCriterion("web_address <=", value, "webAddress");
            return (Criteria) this;
        }

        public Criteria andWebAddressLike(String value) {
            addCriterion("web_address like", value, "webAddress");
            return (Criteria) this;
        }

        public Criteria andWebAddressNotLike(String value) {
            addCriterion("web_address not like", value, "webAddress");
            return (Criteria) this;
        }

        public Criteria andWebAddressIn(List<String> values) {
            addCriterion("web_address in", values, "webAddress");
            return (Criteria) this;
        }

        public Criteria andWebAddressNotIn(List<String> values) {
            addCriterion("web_address not in", values, "webAddress");
            return (Criteria) this;
        }

        public Criteria andWebAddressBetween(String value1, String value2) {
            addCriterion("web_address between", value1, value2, "webAddress");
            return (Criteria) this;
        }

        public Criteria andWebAddressNotBetween(String value1, String value2) {
            addCriterion("web_address not between", value1, value2, "webAddress");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion("remarks is null");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion("remarks is not null");
            return (Criteria) this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion("remarks =", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion("remarks <>", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion("remarks >", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion("remarks >=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion("remarks <", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion("remarks <=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLike(String value) {
            addCriterion("remarks like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotLike(String value) {
            addCriterion("remarks not like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksIn(List<String> values) {
            addCriterion("remarks in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotIn(List<String> values) {
            addCriterion("remarks not in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion("remarks between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion("remarks not between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNull() {
            addCriterion("create_by is null");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNotNull() {
            addCriterion("create_by is not null");
            return (Criteria) this;
        }

        public Criteria andCreateByEqualTo(String value) {
            addCriterion("create_by =", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotEqualTo(String value) {
            addCriterion("create_by <>", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThan(String value) {
            addCriterion("create_by >", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThanOrEqualTo(String value) {
            addCriterion("create_by >=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThan(String value) {
            addCriterion("create_by <", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThanOrEqualTo(String value) {
            addCriterion("create_by <=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLike(String value) {
            addCriterion("create_by like", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotLike(String value) {
            addCriterion("create_by not like", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByIn(List<String> values) {
            addCriterion("create_by in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotIn(List<String> values) {
            addCriterion("create_by not in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByBetween(String value1, String value2) {
            addCriterion("create_by between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotBetween(String value1, String value2) {
            addCriterion("create_by not between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("create_date is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("create_date is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterion("create_date =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterion("create_date <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterion("create_date >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("create_date >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterion("create_date <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("create_date <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterion("create_date in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterion("create_date not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("create_date between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("create_date not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNull() {
            addCriterion("update_by is null");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNotNull() {
            addCriterion("update_by is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateByEqualTo(String value) {
            addCriterion("update_by =", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotEqualTo(String value) {
            addCriterion("update_by <>", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThan(String value) {
            addCriterion("update_by >", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThanOrEqualTo(String value) {
            addCriterion("update_by >=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThan(String value) {
            addCriterion("update_by <", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThanOrEqualTo(String value) {
            addCriterion("update_by <=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLike(String value) {
            addCriterion("update_by like", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotLike(String value) {
            addCriterion("update_by not like", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByIn(List<String> values) {
            addCriterion("update_by in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotIn(List<String> values) {
            addCriterion("update_by not in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByBetween(String value1, String value2) {
            addCriterion("update_by between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotBetween(String value1, String value2) {
            addCriterion("update_by not between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNull() {
            addCriterion("update_date is null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNotNull() {
            addCriterion("update_date is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateEqualTo(Date value) {
            addCriterion("update_date =", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotEqualTo(Date value) {
            addCriterion("update_date <>", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThan(Date value) {
            addCriterion("update_date >", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("update_date >=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThan(Date value) {
            addCriterion("update_date <", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThanOrEqualTo(Date value) {
            addCriterion("update_date <=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIn(List<Date> values) {
            addCriterion("update_date in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotIn(List<Date> values) {
            addCriterion("update_date not in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateBetween(Date value1, Date value2) {
            addCriterion("update_date between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotBetween(Date value1, Date value2) {
            addCriterion("update_date not between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andDelFlagIsNull() {
            addCriterion("del_flag is null");
            return (Criteria) this;
        }

        public Criteria andDelFlagIsNotNull() {
            addCriterion("del_flag is not null");
            return (Criteria) this;
        }

        public Criteria andDelFlagEqualTo(String value) {
            addCriterion("del_flag =", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagNotEqualTo(String value) {
            addCriterion("del_flag <>", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagGreaterThan(String value) {
            addCriterion("del_flag >", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagGreaterThanOrEqualTo(String value) {
            addCriterion("del_flag >=", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagLessThan(String value) {
            addCriterion("del_flag <", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagLessThanOrEqualTo(String value) {
            addCriterion("del_flag <=", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagLike(String value) {
            addCriterion("del_flag like", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagNotLike(String value) {
            addCriterion("del_flag not like", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagIn(List<String> values) {
            addCriterion("del_flag in", values, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagNotIn(List<String> values) {
            addCriterion("del_flag not in", values, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagBetween(String value1, String value2) {
            addCriterion("del_flag between", value1, value2, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagNotBetween(String value1, String value2) {
            addCriterion("del_flag not between", value1, value2, "delFlag");
            return (Criteria) this;
        }

        public Criteria andQualificationCertificateIsNull() {
            addCriterion("qualification_certificate is null");
            return (Criteria) this;
        }

        public Criteria andQualificationCertificateIsNotNull() {
            addCriterion("qualification_certificate is not null");
            return (Criteria) this;
        }

        public Criteria andQualificationCertificateEqualTo(String value) {
            addCriterion("qualification_certificate =", value, "qualificationCertificate");
            return (Criteria) this;
        }

        public Criteria andQualificationCertificateNotEqualTo(String value) {
            addCriterion("qualification_certificate <>", value, "qualificationCertificate");
            return (Criteria) this;
        }

        public Criteria andQualificationCertificateGreaterThan(String value) {
            addCriterion("qualification_certificate >", value, "qualificationCertificate");
            return (Criteria) this;
        }

        public Criteria andQualificationCertificateGreaterThanOrEqualTo(String value) {
            addCriterion("qualification_certificate >=", value, "qualificationCertificate");
            return (Criteria) this;
        }

        public Criteria andQualificationCertificateLessThan(String value) {
            addCriterion("qualification_certificate <", value, "qualificationCertificate");
            return (Criteria) this;
        }

        public Criteria andQualificationCertificateLessThanOrEqualTo(String value) {
            addCriterion("qualification_certificate <=", value, "qualificationCertificate");
            return (Criteria) this;
        }

        public Criteria andQualificationCertificateLike(String value) {
            addCriterion("qualification_certificate like", value, "qualificationCertificate");
            return (Criteria) this;
        }

        public Criteria andQualificationCertificateNotLike(String value) {
            addCriterion("qualification_certificate not like", value, "qualificationCertificate");
            return (Criteria) this;
        }

        public Criteria andQualificationCertificateIn(List<String> values) {
            addCriterion("qualification_certificate in", values, "qualificationCertificate");
            return (Criteria) this;
        }

        public Criteria andQualificationCertificateNotIn(List<String> values) {
            addCriterion("qualification_certificate not in", values, "qualificationCertificate");
            return (Criteria) this;
        }

        public Criteria andQualificationCertificateBetween(String value1, String value2) {
            addCriterion("qualification_certificate between", value1, value2, "qualificationCertificate");
            return (Criteria) this;
        }

        public Criteria andQualificationCertificateNotBetween(String value1, String value2) {
            addCriterion("qualification_certificate not between", value1, value2, "qualificationCertificate");
            return (Criteria) this;
        }

        public Criteria andBlRegiserNoIsNull() {
            addCriterion("bl_regiser_No is null");
            return (Criteria) this;
        }

        public Criteria andBlRegiserNoIsNotNull() {
            addCriterion("bl_regiser_No is not null");
            return (Criteria) this;
        }

        public Criteria andBlRegiserNoEqualTo(String value) {
            addCriterion("bl_regiser_No =", value, "blRegiserNo");
            return (Criteria) this;
        }

        public Criteria andBlRegiserNoNotEqualTo(String value) {
            addCriterion("bl_regiser_No <>", value, "blRegiserNo");
            return (Criteria) this;
        }

        public Criteria andBlRegiserNoGreaterThan(String value) {
            addCriterion("bl_regiser_No >", value, "blRegiserNo");
            return (Criteria) this;
        }

        public Criteria andBlRegiserNoGreaterThanOrEqualTo(String value) {
            addCriterion("bl_regiser_No >=", value, "blRegiserNo");
            return (Criteria) this;
        }

        public Criteria andBlRegiserNoLessThan(String value) {
            addCriterion("bl_regiser_No <", value, "blRegiserNo");
            return (Criteria) this;
        }

        public Criteria andBlRegiserNoLessThanOrEqualTo(String value) {
            addCriterion("bl_regiser_No <=", value, "blRegiserNo");
            return (Criteria) this;
        }

        public Criteria andBlRegiserNoLike(String value) {
            addCriterion("bl_regiser_No like", value, "blRegiserNo");
            return (Criteria) this;
        }

        public Criteria andBlRegiserNoNotLike(String value) {
            addCriterion("bl_regiser_No not like", value, "blRegiserNo");
            return (Criteria) this;
        }

        public Criteria andBlRegiserNoIn(List<String> values) {
            addCriterion("bl_regiser_No in", values, "blRegiserNo");
            return (Criteria) this;
        }

        public Criteria andBlRegiserNoNotIn(List<String> values) {
            addCriterion("bl_regiser_No not in", values, "blRegiserNo");
            return (Criteria) this;
        }

        public Criteria andBlRegiserNoBetween(String value1, String value2) {
            addCriterion("bl_regiser_No between", value1, value2, "blRegiserNo");
            return (Criteria) this;
        }

        public Criteria andBlRegiserNoNotBetween(String value1, String value2) {
            addCriterion("bl_regiser_No not between", value1, value2, "blRegiserNo");
            return (Criteria) this;
        }

        public Criteria andBlAddressIsNull() {
            addCriterion("bl_address is null");
            return (Criteria) this;
        }

        public Criteria andBlAddressIsNotNull() {
            addCriterion("bl_address is not null");
            return (Criteria) this;
        }

        public Criteria andBlAddressEqualTo(String value) {
            addCriterion("bl_address =", value, "blAddress");
            return (Criteria) this;
        }

        public Criteria andBlAddressNotEqualTo(String value) {
            addCriterion("bl_address <>", value, "blAddress");
            return (Criteria) this;
        }

        public Criteria andBlAddressGreaterThan(String value) {
            addCriterion("bl_address >", value, "blAddress");
            return (Criteria) this;
        }

        public Criteria andBlAddressGreaterThanOrEqualTo(String value) {
            addCriterion("bl_address >=", value, "blAddress");
            return (Criteria) this;
        }

        public Criteria andBlAddressLessThan(String value) {
            addCriterion("bl_address <", value, "blAddress");
            return (Criteria) this;
        }

        public Criteria andBlAddressLessThanOrEqualTo(String value) {
            addCriterion("bl_address <=", value, "blAddress");
            return (Criteria) this;
        }

        public Criteria andBlAddressLike(String value) {
            addCriterion("bl_address like", value, "blAddress");
            return (Criteria) this;
        }

        public Criteria andBlAddressNotLike(String value) {
            addCriterion("bl_address not like", value, "blAddress");
            return (Criteria) this;
        }

        public Criteria andBlAddressIn(List<String> values) {
            addCriterion("bl_address in", values, "blAddress");
            return (Criteria) this;
        }

        public Criteria andBlAddressNotIn(List<String> values) {
            addCriterion("bl_address not in", values, "blAddress");
            return (Criteria) this;
        }

        public Criteria andBlAddressBetween(String value1, String value2) {
            addCriterion("bl_address between", value1, value2, "blAddress");
            return (Criteria) this;
        }

        public Criteria andBlAddressNotBetween(String value1, String value2) {
            addCriterion("bl_address not between", value1, value2, "blAddress");
            return (Criteria) this;
        }

        public Criteria andBlDateIsNull() {
            addCriterion("bl_date is null");
            return (Criteria) this;
        }

        public Criteria andBlDateIsNotNull() {
            addCriterion("bl_date is not null");
            return (Criteria) this;
        }

        public Criteria andBlDateEqualTo(String value) {
            addCriterion("bl_date =", value, "blDate");
            return (Criteria) this;
        }

        public Criteria andBlDateNotEqualTo(String value) {
            addCriterion("bl_date <>", value, "blDate");
            return (Criteria) this;
        }

        public Criteria andBlDateGreaterThan(String value) {
            addCriterion("bl_date >", value, "blDate");
            return (Criteria) this;
        }

        public Criteria andBlDateGreaterThanOrEqualTo(String value) {
            addCriterion("bl_date >=", value, "blDate");
            return (Criteria) this;
        }

        public Criteria andBlDateLessThan(String value) {
            addCriterion("bl_date <", value, "blDate");
            return (Criteria) this;
        }

        public Criteria andBlDateLessThanOrEqualTo(String value) {
            addCriterion("bl_date <=", value, "blDate");
            return (Criteria) this;
        }

        public Criteria andBlDateLike(String value) {
            addCriterion("bl_date like", value, "blDate");
            return (Criteria) this;
        }

        public Criteria andBlDateNotLike(String value) {
            addCriterion("bl_date not like", value, "blDate");
            return (Criteria) this;
        }

        public Criteria andBlDateIn(List<String> values) {
            addCriterion("bl_date in", values, "blDate");
            return (Criteria) this;
        }

        public Criteria andBlDateNotIn(List<String> values) {
            addCriterion("bl_date not in", values, "blDate");
            return (Criteria) this;
        }

        public Criteria andBlDateBetween(String value1, String value2) {
            addCriterion("bl_date between", value1, value2, "blDate");
            return (Criteria) this;
        }

        public Criteria andBlDateNotBetween(String value1, String value2) {
            addCriterion("bl_date not between", value1, value2, "blDate");
            return (Criteria) this;
        }

        public Criteria andBlCourseIsNull() {
            addCriterion("bl_course is null");
            return (Criteria) this;
        }

        public Criteria andBlCourseIsNotNull() {
            addCriterion("bl_course is not null");
            return (Criteria) this;
        }

        public Criteria andBlCourseEqualTo(String value) {
            addCriterion("bl_course =", value, "blCourse");
            return (Criteria) this;
        }

        public Criteria andBlCourseNotEqualTo(String value) {
            addCriterion("bl_course <>", value, "blCourse");
            return (Criteria) this;
        }

        public Criteria andBlCourseGreaterThan(String value) {
            addCriterion("bl_course >", value, "blCourse");
            return (Criteria) this;
        }

        public Criteria andBlCourseGreaterThanOrEqualTo(String value) {
            addCriterion("bl_course >=", value, "blCourse");
            return (Criteria) this;
        }

        public Criteria andBlCourseLessThan(String value) {
            addCriterion("bl_course <", value, "blCourse");
            return (Criteria) this;
        }

        public Criteria andBlCourseLessThanOrEqualTo(String value) {
            addCriterion("bl_course <=", value, "blCourse");
            return (Criteria) this;
        }

        public Criteria andBlCourseLike(String value) {
            addCriterion("bl_course like", value, "blCourse");
            return (Criteria) this;
        }

        public Criteria andBlCourseNotLike(String value) {
            addCriterion("bl_course not like", value, "blCourse");
            return (Criteria) this;
        }

        public Criteria andBlCourseIn(List<String> values) {
            addCriterion("bl_course in", values, "blCourse");
            return (Criteria) this;
        }

        public Criteria andBlCourseNotIn(List<String> values) {
            addCriterion("bl_course not in", values, "blCourse");
            return (Criteria) this;
        }

        public Criteria andBlCourseBetween(String value1, String value2) {
            addCriterion("bl_course between", value1, value2, "blCourse");
            return (Criteria) this;
        }

        public Criteria andBlCourseNotBetween(String value1, String value2) {
            addCriterion("bl_course not between", value1, value2, "blCourse");
            return (Criteria) this;
        }

        public Criteria andOrganizationalCodeIsNull() {
            addCriterion("organizational_code is null");
            return (Criteria) this;
        }

        public Criteria andOrganizationalCodeIsNotNull() {
            addCriterion("organizational_code is not null");
            return (Criteria) this;
        }

        public Criteria andOrganizationalCodeEqualTo(String value) {
            addCriterion("organizational_code =", value, "organizationalCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationalCodeNotEqualTo(String value) {
            addCriterion("organizational_code <>", value, "organizationalCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationalCodeGreaterThan(String value) {
            addCriterion("organizational_code >", value, "organizationalCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationalCodeGreaterThanOrEqualTo(String value) {
            addCriterion("organizational_code >=", value, "organizationalCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationalCodeLessThan(String value) {
            addCriterion("organizational_code <", value, "organizationalCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationalCodeLessThanOrEqualTo(String value) {
            addCriterion("organizational_code <=", value, "organizationalCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationalCodeLike(String value) {
            addCriterion("organizational_code like", value, "organizationalCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationalCodeNotLike(String value) {
            addCriterion("organizational_code not like", value, "organizationalCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationalCodeIn(List<String> values) {
            addCriterion("organizational_code in", values, "organizationalCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationalCodeNotIn(List<String> values) {
            addCriterion("organizational_code not in", values, "organizationalCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationalCodeBetween(String value1, String value2) {
            addCriterion("organizational_code between", value1, value2, "organizationalCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationalCodeNotBetween(String value1, String value2) {
            addCriterion("organizational_code not between", value1, value2, "organizationalCode");
            return (Criteria) this;
        }

        public Criteria andHonorsIsNull() {
            addCriterion("honors is null");
            return (Criteria) this;
        }

        public Criteria andHonorsIsNotNull() {
            addCriterion("honors is not null");
            return (Criteria) this;
        }

        public Criteria andHonorsEqualTo(String value) {
            addCriterion("honors =", value, "honors");
            return (Criteria) this;
        }

        public Criteria andHonorsNotEqualTo(String value) {
            addCriterion("honors <>", value, "honors");
            return (Criteria) this;
        }

        public Criteria andHonorsGreaterThan(String value) {
            addCriterion("honors >", value, "honors");
            return (Criteria) this;
        }

        public Criteria andHonorsGreaterThanOrEqualTo(String value) {
            addCriterion("honors >=", value, "honors");
            return (Criteria) this;
        }

        public Criteria andHonorsLessThan(String value) {
            addCriterion("honors <", value, "honors");
            return (Criteria) this;
        }

        public Criteria andHonorsLessThanOrEqualTo(String value) {
            addCriterion("honors <=", value, "honors");
            return (Criteria) this;
        }

        public Criteria andHonorsLike(String value) {
            addCriterion("honors like", value, "honors");
            return (Criteria) this;
        }

        public Criteria andHonorsNotLike(String value) {
            addCriterion("honors not like", value, "honors");
            return (Criteria) this;
        }

        public Criteria andHonorsIn(List<String> values) {
            addCriterion("honors in", values, "honors");
            return (Criteria) this;
        }

        public Criteria andHonorsNotIn(List<String> values) {
            addCriterion("honors not in", values, "honors");
            return (Criteria) this;
        }

        public Criteria andHonorsBetween(String value1, String value2) {
            addCriterion("honors between", value1, value2, "honors");
            return (Criteria) this;
        }

        public Criteria andHonorsNotBetween(String value1, String value2) {
            addCriterion("honors not between", value1, value2, "honors");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}